CREATE OR REPLACE
PACKAGE download_source_pkg
AS
  FUNCTION get_object_type( p_type IN VARCHAR2 ) RETURN VARCHAR2;
  FUNCTION get_file_name
    ( p_object_name IN VARCHAR2,
      p_object_type IN VARCHAR2 ) RETURN VARCHAR2;
  FUNCTION get_ddl
    ( p_owner IN VARCHAR2,
      p_object_name IN VARCHAR2,
      p_object_type IN VARCHAR2 ) RETURN CLOB;
  PROCEDURE write_to_file
    ( p_dir IN VARCHAR2,
      p_filename IN VARCHAR2,
      p_file IN CLOB );
  PROCEDURE get_ddl_write_to_file
    ( p_owner IN VARCHAR2,
      p_object_name IN VARCHAR2,
      p_object_type IN VARCHAR2,
      p_dir IN VARCHAR2 );
END download_source_pkg;
/
show errors
